CREATE TABLE [dbo].[ListReq]
(
[Ik_ListReq] [int] NOT NULL IDENTITY(1, 1),
[Ik_RefReq] [int] NOT NULL,
[Ik_ReqWork] [int] NOT NULL,
[Expdoc] [varchar] (30) COLLATE Cyrillic_General_CI_AS NOT NULL
)
GO
ALTER TABLE [dbo].[ListReq] ADD CONSTRAINT [ListReqPrimary] PRIMARY KEY CLUSTERED  ([Ik_ListReq])
GO
ALTER TABLE [dbo].[ListReq] ADD CONSTRAINT [ListReqRefReqForeign] FOREIGN KEY ([Ik_RefReq]) REFERENCES [dbo].[RefReq] ([Ik_RefReq])
GO
ALTER TABLE [dbo].[ListReq] ADD CONSTRAINT [ListReqReqWorkForeign] FOREIGN KEY ([Ik_ReqWork]) REFERENCES [dbo].[ReqWork] ([Ik_ReqWork]) ON DELETE CASCADE
GO
